2016-03-08 - 25466.100 - Service Request - ReCAP Inactive and resolved tickets #CrystalReportsSupport

Service Request

25466 - ReCAP Inactive and resolved tickets

Problem Summary

ReCAP reports are showing some old tickets under Projects- Inactive- Resolved section need to exclude the section.

Admin Info

Purpose
 ReCAP reports are showing some old tickets under Projects- Inactive- Resolved section need to exclude the section.
Requested by
 Jack Mehltretter
Issue Date
 03-08-2016
Resolved by
 Uday Kumar P
Resolved Date
 03-07-2016
Document Status
 Completed

Detailed Problem Description

Email From Saravanan on 03/07/2016:
There are several ReCAP reports under ReCAP folder in BI Prod which are showing up some tickets under PROJECTS - INACTIVE - RESOLVED section. Few ex-employees are being shown there as well. Ex : Daniela Abraham. All those tickets should not be displayed. Major reports will involve RCP200, RCP210, RCP220, RCP270 and RCP300. Please go through other reports and see whether there are any resolved projects still being shown.

Solution Analysis and Recommendations

There are several ReCAP reports under ReCAP folder in BI Prod which are showing up some tickets under PROJECTS - INACTIVE - RESOLVED section and few Ex-employees are being shown that need to be fixed. The list of reports are as follows:
  1. RCP200
  2. RCP210
  3. RCP220
  4. RCP260
  5. RCP270
  6. RCP300
  7. RCP330

Resolution

Implemented the new logic where Project-Inactive-Resolved will not be displayed in ReCAP reports. The logic in record selection that was added is as follows:
not ({@Work Status} ="Inactive"
and {tblStatusCode.Status_Code} = "Resolved")